-- common..p_InsItem 0,'P','UIIO','VT','AB','III','III', 90.0,67.0,7.0,120,78.0,89.0,0.0,null,1348.0,'Test'
-----------------------------------------------------------------------------
-- DDL for Table'common.dbo.t_Payment'
-----------------------------------------------------------------------------
print 'Creating Table common.dbo.t_Payment'
go 

use common
go 

setuser 'dbo'
go 
drop table t_Payment
go
create table t_Payment (
	CustomerID           	varchar(50)						NULL,	   	-- CustomerID
	InvoiceNumber           varchar(50)						NULL,	   	-- InvoiceNumber
	CustomerName          	varchar(50)						NULL,	   	-- CustomerName
	OpenAmount           	decimal(10,4)					NULL,	   	-- OpenAmount
	PaymentAmount           decimal(10,4)					NULL,	   	-- PaymentAmount
	PaymentDate           	datetime						NULL,	   	-- PaymentDate
	CompanyName				varchar(30)						NULL	   	--  belong to which Company
)
go
Grant Select on dbo.t_Payment to public 
go
setuser
go